/*use cdcache_innodb_mit_pk_mit_fk;*/
/*use cdcacheinnodbmitprimarykeyohnefremds;*/
/*use cdcacheinnodbohnekeys;*/
/*use cdcachemitpkindexpartitionierung;*/
/*use cdcachemyisam_mit_pk_mit_ref_mit_index_mit_partitionierung;*/
/*use cdcachemyisam_mirPK_mit_FK;*/
/*use cdcachemyisam_mit_PK_ohne_Ref;*/
/*use use cdcachemyisamohnepkref;*/


/***********************************************************/
/*Alle Cds zu einem Interpreten                            */
/***********************************************************/
explain extended select title from cds join artists on cds.artistId = artists.artistId 
where artists.name = 'ZZ Top'; 

show warnings

show status like 'last_query_cost'

/*************************************************************/
/*Alle Tracks zu einem Interpreten			     */
/*************************************************************/
explain extended select tracks.title from (tracks join cds on tracks.cddbId = cds.cddbId) 
join artists on cds.artistId = artists.artistId
where artists.name = 'ZZ Top';												  	   
show warnings

show status like 'last_query_cost'

/********************************************************/
/*Alle Cds die zu einem Genre gehren			*/
/********************************************************/
explain extended select title from cds join genres on cds.genreId = genres.genreId 
where genres.genre = 'Pop';

show warnings

show status like 'last_query_cost'

/**************************************************************************/
/*Alle Interpreten die zu einem Genre gehren				  */
/**************************************************************************/
explain extended select artists.name from (artists join cds on artists.artistId = cds.artistId) 
join genres on cds.genreId = genres.genreId
where genres.genre = 'Pop';

show warnings

show status like 'last_query_cost'

/***************************************************/
/*Alle Tracks auf einer Cds			   */
/***************************************************/
explain extended select tracks.title from tracks join cds on tracks.cddbId = cds.cddbId 
where cds.title = 'Zweiohrkueken';

show warnings

show status like 'last_query_cost'
